<?php
    include_once '../../../../controlador/php/conexion/Conexion10.php';
    $con = new Conexion10();
    
    $select = "select OID,HSUNOMBRE from HPNSUBGRU where OID not in(20) order by HSUNOMBRE";
    $res = $con->query($select);
    
    while($res2 = mssql_fetch_array($res)){
        $lista[] = array_map(utf8_encode,$res2);
    }
    
    print_r(json_encode($lista));
    
    $con->cerrarConexion();
?>
